CREATE TABLE [dbo].[TRTIOP_CNTB]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[CO_TIPO_OPER] [dbo].[TD_VC_003] NOT NULL,
[CO_CNTA_EMPR] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TRTIOP_CN__CO_US__01741E54] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TRTIOP_CN__FE_US__0268428D] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TRTIOP_CN__CO_US__035C66C6] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TRTIOP_CN__FE_US__04508AFF] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TRTIOP_CNTB] ADD CONSTRAINT [PK__TRTIOP_C__4EFA88781FCE8842] PRIMARY KEY CLUSTERED  ([CO_EMPR], [CO_TIPO_OPER], [CO_CNTA_EMPR]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TRTIOP_CNTB] ADD CONSTRAINT [FK__TRTIOP_CNTB__24B338F0] FOREIGN KEY ([CO_EMPR], [CO_TIPO_OPER]) REFERENCES [dbo].[TTTIPO_OPER] ([CO_EMPR], [CO_TIPO_OPER])
GO
